P&I AG
1 Intoduction
Hello, I’m Joseph from Morocco.
Inspired by Hans Rosling’s TED Talk, I taught myself data scraping, analysis, and visualization.
This non-academic approach has given me a unique perspective, as reflected in my projects—though it also means I may require a thorough onboarding process to align with team standards.
I’m open to starting as an intern, either full-time or part-time. Regarding time zones, I’m in UTC+1, but I’m flexible and can adjust my schedule to accommodate the team’s needs.
Feel free to reach me at joseph.ergo@proton.me, and to visit my website for more projects josephelhaddad.github.io.
This custom report, generated from processing 1.4 TB of public data locally, aims to explore the workforce dynamics of a company—up to 2020.
Essentially, I am doing research on a company that does research.
2 About the project
The project came to life after realizing that web scraping doesn’t allow deep-level filtering—without consuming too much time.The irony is, this project itself took me about a month, but the final RDB contains more data than I could ever scrape.
The raw data was 1.4 TB in size and holds information previously scraped.
Processing was done on my local machine using Python, Polars, and DuckDB, following this workflow:
- Processed raw data into structured Parquet files using Polars.
- Transformed each Parquet file into mini RDBs using Polars.
- Merged all mini RDBs into one using DuckDB.
- Analyzed and filtered data to fit the current project.
3 EDA
3.1 computer software indestry’s yearly new recruit count
3.2 p&i ag’s workforce status over the years
4 Workforce sample
4.1 Adriano Santagapita
Job title: Sales manager
Associated: False
Socials: https://linkedin.com/in/adriano-santagapita-0b324a5a | https://linkedin.com/in/adriano-a-santagapita-0b324a5a
4.1.1 Adriano Santagapita’s working period at p&i ag
4.1.2 Gantt plot of Adriano Santagapita’s experience
4.2 Amirul Bin Haji Jali
Job title: P and i and marine
Associated: True
Socials: https://linkedin.com/in/amirul-ikwan-bin-haji-jali...
4.2.1 Amirul Bin Haji Jali’s working period at p&i ag
4.2.2 Gantt plot of Amirul Bin Haji Jali’s experience
4.3 Andre Piag
Job title: Softwareentwickler
Associated: True
Socials: https://linkedin.com/in/andre-piag-2860a8136
4.3.1 Andre Piag’s working period at p&i ag
4.3.2 Gantt plot of Andre Piag’s experience
4.4 Andrea Burikova
Job title: Consulting it
Associated: True
Socials: https://linkedin.com/in/andrea-burikova-3634a89
4.4.1 Andrea Burikova’s working period at p&i ag
4.4.2 Gantt plot of Andrea Burikova’s experience
4.5 Andrej Minarik
Job title: Product manager
Associated: True
Socials: https://linkedin.com/in/andrej-minarik-18512b3
4.5.1 Andrej Minarik’s working period at p&i ag
4.5.2 Gantt plot of Andrej Minarik’s experience
4.6 Aurelia Gezynska
Job title: Human resources -sales
Associated: True
Socials: https://linkedin.com/in/aurelia-gezynska-545973b4
4.6.1 Aurelia Gezynska’s working period at p&i ag
4.6.2 Gantt plot of Aurelia Gezynska’s experience
4.7 Brendan Ryan
Job title: Director of development
Associated: True
Socials: https://linkedin.com/in/brendan-ryan-13762a4
4.7.1 Brendan Ryan’s working period at p&i ag
4.7.2 Gantt plot of Brendan Ryan’s experience
4.8 Brigitte Goldmann
Job title: Qualitã tssicherung
Associated: True
Socials: https://linkedin.com/in/brigitte-goldmann-46752a33
4.8.1 Brigitte Goldmann’s working period at p&i ag
4.8.2 Gantt plot of Brigitte Goldmann’s experience
4.9 Christos Triadis
Job title: Geschã ftsfã¼hrer bei p and i ag
Associated: True
Socials: https://linkedin.com/in/christos-triadis-4779bb13
4.9.1 Christos Triadis’s working period at p&i ag
4.9.2 Gantt plot of Christos Triadis’s experience
4.10 David Hippe
Job title: System engineer
Associated: True
Socials: https://linkedin.com/in/david-hippe-1270598 | https://linkedin.com/in/david-hippe-127598
4.10.1 David Hippe’s working period at p&i ag
4.10.2 Gantt plot of David Hippe’s experience
4.11 Denis Schvarcz
Job title: Cee sales
Associated: False
Socials: https://linkedin.com/in/denis-schvarcz-1268571b | https://twitter.com/bohumilstejskal | https://linkedin.com/in/denisschvarcz
4.11.1 Denis Schvarcz’s working period at p&i ag
4.11.2 Gantt plot of Denis Schvarcz’s experience
4.12 Emiliano Paoletti
Job title: Ingegnere
Associated: False
Socials: https://linkedin.com/in/ingemilianopaoletti | https://linkedin.com/in/emiliano-paoletti-250b0a2a
4.12.1 Emiliano Paoletti’s working period at p&i ag
4.12.2 Gantt plot of Emiliano Paoletti’s experience
4.13 Eric Gagnolet
Job title: Sales manager bei p and i ag
Associated: True
Socials: https://linkedin.com/in/eric-gagnolet-56646483
4.13.1 Eric Gagnolet’s working period at p&i ag
4.13.2 Gantt plot of Eric Gagnolet’s experience
4.14 Gerhard Hiebsch
Job title: Software-entwickler
Associated: True
Socials: https://linkedin.com/in/gerhard-hiebsch-70116774
4.14.1 Gerhard Hiebsch’s working period at p&i ag
4.14.2 Gantt plot of Gerhard Hiebsch’s experience
4.15 Guido Blitz
Job title: Sales manager
Associated: True
Socials: https://linkedin.com/in/guido-blitz-baaa6620
4.15.1 Guido Blitz’s working period at p&i ag
4.15.2 Gantt plot of Guido Blitz’s experience
4.16 Herr Scholz
Job title: Key accout manager
Associated: True
Socials: https://linkedin.com/in/herr-scholz-84925386
4.16.1 Herr Scholz’s working period at p&i ag
4.16.2 Gantt plot of Herr Scholz’s experience
4.17 Ioannis Konstantakis
Job title: It
Associated: True
Socials: https://linkedin.com/in/ioannis-konstantakis-a812b632 | https://twitter.com/i_konstantakis | https://linkedin.com/in/ikonstantakis
4.17.1 Ioannis Konstantakis’s working period at p&i ag
4.17.2 Gantt plot of Ioannis Konstantakis’s experience
4.18 Ioannis Triadis
Job title: Senior consultant
Associated: True
Socials: https://linkedin.com/in/ioannis-triadis-28670122
4.18.1 Ioannis Triadis’s working period at p&i ag
4.18.2 Gantt plot of Ioannis Triadis’s experience
4.19 Isabel Mohr
Job title: Senior consultant and projektmanagement
Associated: True
Socials: https://linkedin.com/in/isabel-mohr-743b2a114
4.19.1 Isabel Mohr’s working period at p&i ag
4.19.2 Gantt plot of Isabel Mohr’s experience
4.20 Jean Delgado
Job title: Especialista cmi
Associated: True
Socials: https://linkedin.com/in/jean-carlos-pelallo-delgado...
4.20.1 Jean Delgado’s working period at p&i ag
4.20.2 Gantt plot of Jean Delgado’s experience
4.21 Kai Wagenknecht
Job title: Bereichsleiter
Associated: True
Socials: https://linkedin.com/in/kai-wagenknecht-8b456398
4.21.1 Kai Wagenknecht’s working period at p&i ag
4.21.2 Gantt plot of Kai Wagenknecht’s experience
4.22 Klaus Huyeng
Job title: Sales manager
Associated: True
Socials: https://linkedin.com/in/klaus-huyeng-028b9642
4.22.1 Klaus Huyeng’s working period at p&i ag
4.22.2 Gantt plot of Klaus Huyeng’s experience
4.23 Klaus Warnke
Job title: Programmierer bei p and i ag
Associated: True
Socials: https://linkedin.com/in/klaus-warnke-74125675
4.23.1 Klaus Warnke’s working period at p&i ag
4.23.2 Gantt plot of Klaus Warnke’s experience
4.24 Käthi Seibert
Job title: Sekretã rin
Associated: True
Socials: https://linkedin.com/in/käthi-seibert-13817374
4.24.1 Käthi Seibert’s working period at p&i ag
4.24.2 Gantt plot of Käthi Seibert’s experience
4.25 Laura Seliger
Job title: Sachbearbeiterin auftragsabwicklung
Associated: True
Socials: https://linkedin.com/in/laura-seliger-b68520170
4.25.1 Laura Seliger’s working period at p&i ag
4.25.2 Gantt plot of Laura Seliger’s experience
4.26 Lisa-Marie Weber
Job title: Content-manager
Associated: True
Socials: https://linkedin.com/in/lisa-marie-weber-17336919a
4.26.1 Lisa-Marie Weber’s working period at p&i ag
4.26.2 Gantt plot of Lisa-Marie Weber’s experience
4.27 Lol Bol
Job title: Electrician
Associated: True
Socials: https://linkedin.com/in/lol-bol-572b27154
4.27.1 Lol Bol’s working period at p&i ag
4.27.2 Gantt plot of Lol Bol’s experience
4.28 Mario Fuchs
Job title: Human resources consultant
Associated: True
Socials: https://linkedin.com/in/mario-fuchs-215583ba
4.28.1 Mario Fuchs’s working period at p&i ag
4.28.2 Gantt plot of Mario Fuchs’s experience
4.29 Martin Fiala
Job title: Consultant
Associated: True
Socials: https://linkedin.com/in/martin-fiala-27a3237a
4.29.1 Martin Fiala’s working period at p&i ag
4.29.2 Gantt plot of Martin Fiala’s experience
4.30 Matej Budzel
Job title: Programmer, analyst
Associated: True
Socials: https://linkedin.com/in/matej-budzel-709b5a44
4.30.1 Matej Budzel’s working period at p&i ag
4.30.2 Gantt plot of Matej Budzel’s experience
4.31 Mayritsch Gudrun
Job title: Seminaradministration
Associated: True
Socials: https://linkedin.com/in/mayritsch-gudrun-93a27675
4.31.1 Mayritsch Gudrun’s working period at p&i ag
4.31.2 Gantt plot of Mayritsch Gudrun’s experience
4.32 Michael Gebauer
Job title: Softwareentwickler
Associated: True
Socials: https://linkedin.com/in/michael-gebauer-09426975
4.32.1 Michael Gebauer’s working period at p&i ag
4.32.2 Gantt plot of Michael Gebauer’s experience
4.33 Michael Müller
Job title: Consulting manager pubplic
Associated: True
Socials: https://linkedin.com/in/michael-müller-6b37b5 | https://linkedin.com/in/michael-mã¼ller-6b37b5
4.33.1 Michael Müller’s working period at p&i ag
4.33.2 Gantt plot of Michael Müller’s experience
4.34 Michael Schimmel
Job title: It-manager
Associated: True
Socials: https://linkedin.com/in/michael-schimmel-69472512a
4.34.1 Michael Schimmel’s working period at p&i ag
4.34.2 Gantt plot of Michael Schimmel’s experience
4.35 Milan Hajas
Job title: Developer
Associated: True
Socials: https://linkedin.com/in/milan-hajas-15104a8
4.35.1 Milan Hajas’s working period at p&i ag
4.35.2 Gantt plot of Milan Hajas’s experience
4.36 Milan Kubov
Job title: Pep and time developer and analyst
Associated: True
Socials: https://linkedin.com/in/milan-kubov-4015356
4.36.1 Milan Kubov’s working period at p&i ag
4.36.2 Gantt plot of Milan Kubov’s experience
4.37 Otto Wanner
Job title: Dozent
Associated: False
Socials: https://linkedin.com/in/otto-wanner-1133b2125
4.37.1 Otto Wanner’s working period at p&i ag
4.37.2 Gantt plot of Otto Wanner’s experience
4.38 Paolo Illari
Job title: Selezionatore porno attrici
Associated: True
Socials: https://linkedin.com/in/paolo-illari-554b9426
4.38.1 Paolo Illari’s working period at p&i ag
4.38.2 Gantt plot of Paolo Illari’s experience
4.39 Peggy Gatani
Job title: Sales manager
Associated: True
Socials: https://linkedin.com/in/peggygatani | https://linkedin.com/in/peggy-gatani-70aab325
4.39.1 Peggy Gatani’s working period at p&i ag
4.39.2 Gantt plot of Peggy Gatani’s experience
4.40 Peter Kolarik
Job title: Senior programmer and analyst
Associated: True
Socials: https://linkedin.com/in/peter-kolarik-9b724993 | https://linkedin.com/in/kolarik-peter-9b724993
4.40.1 Peter Kolarik’s working period at p&i ag
4.40.2 Gantt plot of Peter Kolarik’s experience
4.41 Peter Vozar
Job title: Developer
Associated: False
Socials: https://linkedin.com/in/peter-vozar-70940131
4.41.1 Peter Vozar’s working period at p&i ag
4.41.2 Gantt plot of Peter Vozar’s experience
4.42 Ralf Heinemann
Job title: Technical consultant
Associated: True
Socials: https://linkedin.com/in/ralfheinemann | https://linkedin.com/in/ralf-heinemann-bb2527b
4.42.1 Ralf Heinemann’s working period at p&i ag
4.42.2 Gantt plot of Ralf Heinemann’s experience
4.43 Ralf Wallenstein
Job title: Qualitã tssicherung
Associated: True
Socials: https://linkedin.com/in/ralf-wallenstein-b1817a74
4.43.1 Ralf Wallenstein’s working period at p&i ag
4.43.2 Gantt plot of Ralf Wallenstein’s experience
4.44 Ralph Kalinke
Job title: Sales manager
Associated: True
Socials: https://linkedin.com/in/ralph-kalinke-09721582 | https://linkedin.com/in/ralph-kalinke-09735356
4.44.1 Ralph Kalinke’s working period at p&i ag
4.44.2 Gantt plot of Ralph Kalinke’s experience
4.45 Rick Driessen
Job title: Consultant
Associated: False
Socials: https://linkedin.com/in/rick-driessen-42a1857 | https://linkedin.com/in/rickdriessen
4.45.1 Rick Driessen’s working period at p&i ag
4.45.2 Gantt plot of Rick Driessen’s experience
4.46 Sandra Braun
Job title: Qualitã tssicherung
Associated: True
Socials: https://linkedin.com/in/sandra-braun-3443021b2
4.46.1 Sandra Braun’s working period at p&i ag
4.46.2 Gantt plot of Sandra Braun’s experience
4.47 Saskia Van Eesteren
Job title: Marketing and sales
Associated: False
Socials: https://linkedin.com/in/saskia-blom-van-eesteren-a52021b | https://linkedin.com/in/saskia-blom-van-eesteren | https://twitter.com/s_assist
4.47.1 Saskia Van Eesteren’s working period at p&i ag
4.47.2 Gantt plot of Saskia Van Eesteren’s experience
4.48 Simona Zucchi
Job title: Addetto alla logistica
Associated: True
Socials: https://linkedin.com/in/simona-zucchi-b4b399167
4.48.1 Simona Zucchi’s working period at p&i ag
4.48.2 Gantt plot of Simona Zucchi’s experience
4.49 Soenke Bradtmoeller
Job title: Consultant
Associated: False
Socials: https://linkedin.com/in/soenke-bradtmoeller-7410918a
4.49.1 Soenke Bradtmoeller’s working period at p&i ag
4.49.2 Gantt plot of Soenke Bradtmoeller’s experience
4.50 Stefan Herrchen
Job title: Key account manager bei p and i ag
Associated: True
Socials: https://linkedin.com/in/stefan-herrchen-254aa917
4.50.1 Stefan Herrchen’s working period at p&i ag
4.50.2 Gantt plot of Stefan Herrchen’s experience
4.51 Stephanie Schäfer
Job title: Vertriebsinnendienst
Associated: False
Socials: https://linkedin.com/in/stephanie-schäfer-076395b1
4.51.1 Stephanie Schäfer’s working period at p&i ag
4.51.2 Gantt plot of Stephanie Schäfer’s experience
4.52 Takaaki Sato
Job title: Manager technical services
Associated: True
Socials: https://linkedin.com/in/takaaki-sato-5007132a
4.52.1 Takaaki Sato’s working period at p&i ag
4.52.2 Gantt plot of Takaaki Sato’s experience
4.53 Tatjana Medic
Job title: It-consultant bei p and i ag
Associated: True
Socials: https://linkedin.com/in/tatjana-medic-5a49987b
4.53.1 Tatjana Medic’s working period at p&i ag
4.53.2 Gantt plot of Tatjana Medic’s experience
4.54 Tom Heisterbach
Job title: Strategic account manager
Associated: True
Socials: https://linkedin.com/in/tom-heisterbach-8a487050 | https://twitter.com/tomheisterbach
4.54.1 Tom Heisterbach’s working period at p&i ag
4.54.2 Gantt plot of Tom Heisterbach’s experience
4.55 Tristan Vellut
Job title: Senior consultant rh
Associated: True
Socials: https://facebook.com/tristan.vellut | https://linkedin.com/in/tristan-vellut-9a5ab965
4.55.1 Tristan Vellut’s working period at p&i ag
4.55.2 Gantt plot of Tristan Vellut’s experience
4.56 Wilson Northamerica
Job title: Ces
Associated: True
Socials: https://linkedin.com/in/wilson-gutierrez-ces-northamerica-12b1285b
4.56.1 Wilson Northamerica’s working period at p&i ag
4.56.2 Gantt plot of Wilson Northamerica’s experience
4.57 Yngve Johnson
Job title: Kommunikasjonsrã dgiver
Associated: False
Socials: https://linkedin.com/in/yngve-johnson-72a97427
4.57.1 Yngve Johnson’s working period at p&i ag
4.57.2 Gantt plot of Yngve Johnson’s experience
4.58 Zubair Parwany
Job title: Software engineer
Associated: True
Socials: https://linkedin.com/in/zubair-parwany-7431515a | https://linkedin.com/in/zubairparwany
4.58.1 Zubair Parwany’s working period at p&i ag
4.58.2 Gantt plot of Zubair Parwany’s experience
4.59 Zuzana Durfinova
Job title: Product development manager and quality assurance
Associated: True
Socials: https://linkedin.com/in/zuzana-durfinova-94b05b41
4.59.1 Zuzana Durfinova’s working period at p&i ag
4.59.2 Gantt plot of Zuzana Durfinova’s experience
4.60 Zuzana Moncekova
Job title: Human resources and office manager
Associated: True
Socials: https://linkedin.com/in/zuzanamoncekova